<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_resume_expect`;");
CreateTable("CREATE TABLE `phpyun_resume_expect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `name` varchar(25) NOT NULL DEFAULT '',
  `hy` int(5) DEFAULT NULL,
  `job_classid` varchar(100) NOT NULL DEFAULT '',
  `provinceid` int(5) DEFAULT NULL,
  `cityid` int(5) DEFAULT NULL,
  `three_cityid` int(5) DEFAULT NULL,
  `salary` int(3) DEFAULT NULL,
  `jobstatus` int(11) DEFAULT NULL,
  `type` int(3) DEFAULT NULL,
  `report` int(3) DEFAULT NULL,
  `defaults` int(1) NOT NULL DEFAULT '0',
  `open` int(1) DEFAULT '1',
  `is_entrust` int(1) DEFAULT '0',
  `full` int(3) DEFAULT '0',
  `doc` int(1) DEFAULT '0',
  `hits` int(6) DEFAULT '0',
  `lastupdate` int(10) NOT NULL,
  `def_job` int(11) DEFAULT NULL,
  `cloudtype` int(2) DEFAULT NULL,
  `integrity` int(11) DEFAULT NULL,
  `height_status` int(11) DEFAULT '0',
  `statusbody` varchar(200) NOT NULL DEFAULT '',
  `status_time` int(11) DEFAULT NULL,
  `rec` int(11) DEFAULT '0',
  `top` int(11) DEFAULT NULL,
  `topdate` int(11) DEFAULT '0',
  `rec_resume` int(11) DEFAULT NULL,
  `source` int(1) DEFAULT '1',
  `tmpid` int(5) DEFAULT NULL,
  `ctime` int(11) DEFAULT NULL,
  `dnum` int(11) DEFAULT '0',
  `did` int(11) DEFAULT NULL,
  `uname` varchar(50) NOT NULL DEFAULT '',
  `idcard_status` int(1) DEFAULT '0',
  `status` int(1) DEFAULT '1',
  `r_status` int(4) DEFAULT '0',
  `edu` int(11) DEFAULT '0',
  `exp` int(11) DEFAULT '0',
  `sex` int(11) DEFAULT '0',
  `photo` varchar(100) NOT NULL DEFAULT '',
  `phototype` int(11) DEFAULT '0',
  `birthday` varchar(15) NOT NULL DEFAULT '',
  `annex` varchar(600) NOT NULL DEFAULT '',
  `annexname` varchar(255) NOT NULL DEFAULT '',
  `minsalary` int(11) NOT NULL,
  `maxsalary` int(11) DEFAULT NULL,
  `whour` int(11) DEFAULT '0',
  `avghour` int(11) DEFAULT '0',
  `content` text,
  `label` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`defaults`),
  KEY `uid` (`uid`),
  KEY `lastupdate` (`lastupdate`),
  KEY `city` (`provinceid`,`cityid`,`three_cityid`) USING BTREE,
  KEY `topdate` (`topdate`),
  KEY `status` (`status`),
  KEY `r_status` (`r_status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_resume_expect` values('1','1','口腔','35','814,485','6','86','0',NULL,'114','57','50','1','1','0','0','0','2','1520407413',NULL,NULL,'55','0','1',NULL,'0',NULL,'0',NULL,'1',NULL,'1520407413','0','0','c1','0','1','1','15','21','2','','0','1990-01-01','','','5000','7000','0','0','test',NULL);");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>